Tabela EportalAccountShare

Definicja tabeli EportalAccountShare

Name

EportalAccountShare

Code

EportalAccountShare

Comment

Informacje o udostepnieniu na okreslony czas dostepu do danych w Eportalu zewnetrznemu uzytkownikowi z danym mailem i telefonem z personID = EportalAccountShare.PersonId


Lista kolumn tabeli EportalAccountShare

Name

Code

UID

UID

PersonID

PersonID

AccessStopDT

AccessStopDT

AccessedPersonEmail

AccessedPersonEmail

AccessedPersonPhone

AccessedPersonPhone

UserPassword

UserPassword


Kolumna UID tabeli EportalAccountShare

Definicja kolumny UID tabeli EportalAccountShare

Name

UID

Code

UID

Data Type

VARCHAR2(40)

Mandatory

Yes

Comment

Unikalny UID wykorzystywany w linku do uwierzytelniania


Kolumna PersonID tabeli EportalAccountShare

Definicja kolumny PersonID tabeli EportalAccountShare

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Id osoby udostepniajacej swoje dane


Kolumna AccessStopDT tabeli EportalAccountShare

Definicja kolumny AccessStopDT tabeli EportalAccountShare

Name

AccessStopDT

Code

AccessStopDT

Data Type

DATE

Mandatory

No

Comment

Czas do kiedy link z UID-em sa aktywne


Kolumna AccessedPersonEmail tabeli EportalAccountShare

Definicja kolumny AccessedPersonEmail tabeli EportalAccountShare

Name

AccessedPersonEmail

Code

AccessedPersonEmail

Data Type

VARCHAR2(80)

Mandatory

No

Comment

E-Mail osoby której dane sa udostepnione,


Kolumna AccessedPersonPhone tabeli EportalAccountShare

Definicja kolumny AccessedPersonPhone tabeli EportalAccountShare

Name

AccessedPersonPhone

Code

AccessedPersonPhone

Data Type

VARCHAR2(11)

Mandatory

No

Comment

Tel. osoby której dane sa udostepnione,


Kolumna UserPassword tabeli EportalAccountShare

Definicja kolumny UserPassword tabeli EportalAccountShare

Name

UserPassword

Code

UserPassword

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Lista kluczy tabeli EportalAccountShare

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli EportalAccountShare

Definicja klucza Identifier_1 tabeli EportalAccountShare

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment